package com.his.registration.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @BelongsProject: workspace-idea
 * @BelongsPackage: com.his.registration.mapper
 * @Author: ZhangYing
 * @Date: 2023/7/1 15:26
 * @Description:
 */
@Mapper
public interface SettleCategoryMapper {
    //查询所有结算方式
    @Select("select settle_name from settle_category")
    public List<String> select();

    //根据name得到id
    @Select("select id from settle_category where settle_name=#{settleName}")
    public int getIdByName(String settleName);
}
